"""
Case Type   : cm_agent参数
Case Name   : 使用gs_guc set -Z cmagent -c方式修改参数upgrade_from值为0
Create At   : 2025/4/8
Owner       : ningyali
Description :
    1.查询参数upgrade_from默认值
    2.修改参数值为0
    3.重启集群
    4.查看参数值
    5.恢复参数默认值
Expect      :
    1.执行成功
    2.执行成功
    3.执行成功
    4.执行成功
    5.执行成功
History     :
"""

import os
import unittest

from testcase.utils.ComInstall import CmInstall
from testcase.utils.ComInstall import CmUnInstall
from testcase.utils.Common import Common
from testcase.utils.CommonSH import CommonSH
from testcase.utils.Logger import Logger
from yat.test import Node
from yat.test import macro


class CMServer(unittest.TestCase):
    def setUp(self):
        self.log = Logger()
        self.log.info(f'-----{os.path.basename(__file__)} start-----')
        self.pri_sh = CommonSH('PrimaryDbUser')
        self.root_nodes = (Node('PrimaryRoot'), Node('Standby1Root'),
                           Node('Standby2Root'))
        self.user_nodes = (Node('PrimaryDbUser'), Node('Standby1DbUser'),
                           Node('Standby2DbUser'))
        self.common = Common()

        text = '----prestep1:安装cm;expect:执行成功----'
        self.log.info(text)
        self.install_pkg_path = os.path.dirname(macro.DB_SCRIPT_PATH)
        self.cm = CmInstall(self.install_pkg_path, self.pri_sh.node.ssh_user)
        res = self.cm.update_xml_for_cm(*self.root_nodes)
        self.assertGreater(res.count('cmDir'), 1, f'执行失败: {text}')

        res = self.cm.cm_install(self.user_nodes[0])
        self.assertIn('Install CM tool success', res, f'执行失败: {text}')

    def test_trans(self):
        text = '----step1:查询参数upgrade_from默认值;expect:执行成功----'
        self.log.info(text)
        q_logdir_cmd = f"source {macro.DB_ENV_PATH};" \
                       f"cm_ctl list --param --agent | grep upgrade_from"
        q_res = self.common.get_sh_result(self.user_nodes[0], q_logdir_cmd)
        self.assertIn('upgrade_from = 0', q_res, f'执行失败: {text}')

        text = '----step2:修改参数值为0;expect:执行成功----'
        self.log.info(text)
        set_cmd = f"source {macro.DB_ENV_PATH};" \
                  f"gs_guc set -Z cmagent -c upgrade_from=\"0\";" \
                  f"gs_guc set -Z cmserver -c upgrade_from=\"0\""
        set_res = self.common.get_sh_result(self.user_nodes[0], set_cmd)
        self.assertEqual(set_res.count('ALL: Success to perform gs_guc'), 2,
                         f'执行失败: {text}')

        text = '----step3:重启集群;expect:执行成功----'
        self.log.info(text)
        restart_cmd = f'source {macro.DB_ENV_PATH};' \
                      f'cm_ctl stop && cm_ctl start'
        restart_res = self.common.get_sh_result(self.user_nodes[0], restart_cmd)
        self.assertEqual(restart_res.count('cluster successfully'), 2,
                         f'执行失败: {text}')

        text = '----step4:查看参数值;expect:执行成功----'
        self.log.info(text)
        q_res = self.common.get_sh_result(self.user_nodes[0], q_logdir_cmd)
        self.assertIn('upgrade_from = 0', q_res, f'执行失败: {text}')

        text = '----step5:恢复参数默认值;expect:执行成功----'
        self.log.info(text)
        set_cmd = f"source {macro.DB_ENV_PATH};" \
                  f"gs_guc set -Z cmagent -c upgrade_from=\"0\";" \
                  f"gs_guc set -Z cmserver -c upgrade_from=\"0\""
        set_res = self.common.get_sh_result(self.user_nodes[0], set_cmd)
        self.assertEqual(set_res.count('ALL: Success to perform gs_guc'), 2,
                         f'执行失败: {text}')

    def tearDown(self):
        text = '----poststep1:卸载cm;expect:执行成功----'
        self.log.info(text)
        self.un_cm = CmUnInstall(self.install_pkg_path,
                                 self.pri_sh.node.ssh_user)
        res = self.un_cm.cm_uninstall(
            self.user_nodes[0], '--deleteData --deleteBinary')
        self.assertIn('Uninstall CM tool success', res, f'执行失败: {text}')
        self.log.info(f'-----{os.path.basename(__file__)} end-----')
